Pandas Profiling Report

Dataset statistics

Number of variables	20
Number of observations	734932
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	122.7 MiB
Average record size in memory	175.0 B

Variable types

Numeric	9
DateTime	1
Categorical	9
Unsupported	1

Alerts

`day_of_week` is highly overall correlated with `open`	High correlation
`customers` is highly overall correlated with `sales`	High correlation
`promo2_since_year` is highly overall correlated with `promo2`	High correlation
`sales` is highly overall correlated with `customers` and 1 other fields	High correlation
`open` is highly overall correlated with `day_of_week` and 1 other fields	High correlation
`store_type` is highly overall correlated with `assortment`	High correlation
`assortment` is highly overall correlated with `store_type`	High correlation
`promo2` is highly overall correlated with `promo2_since_year`	High correlation
`state_holiday` is highly imbalanced (88.2%)	Imbalance
`promo_interval` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`customers` has 124977 (17.0%) zeros	Zeros
`sales` has 124979 (17.0%) zeros	Zeros

Reproduction

Analysis started	2023-06-12 18:58:59.203622
Analysis finished	2023-06-12 18:59:43.698889
Duration	44.5 seconds
Software version	pandas-profiling v0.0.dev0
Download configuration	config.json

store
Real number (ℝ)

Distinct	1115
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	558.51995

Minimum	1
Maximum	1115
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.2 MiB

Quantile statistics

Minimum	1
5-th percentile	56
Q1	281
median	558
Q3	837
95-th percentile	1060
Maximum	1115
Range	1114
Interquartile range (IQR)	556

Descriptive statistics

Standard deviation	321.87006
Coefficient of variation (CV)	0.57629107
Kurtosis	-1.199737
Mean	558.51995
Median Absolute Deviation (MAD)	278
Skewness	-0.0014385114
Sum	4.1047418 × 10⁸
Variance	103600.34
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
885	727	0.1%
116	720	0.1%
381	719	0.1%
881	717	0.1%
102	716	0.1%
544	715	0.1%
757	713	0.1%
246	712	0.1%
511	711	0.1%
847	711	0.1%
Other values (1105)	727771	99.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	676	0.1%
2	681	0.1%
3	689	0.1%
4	683	0.1%
5	682	0.1%
6	685	0.1%
7	670	0.1%
8	675	0.1%
9	668	0.1%
10	680	0.1%

Value	Count	Frequency (%)
1115	674	0.1%
1114	686	0.1%
1113	687	0.1%
1112	690	0.1%
1111	668	0.1%
1110	670	0.1%
1109	564	0.1%
1108	684	0.1%
1107	568	0.1%
1106	674	0.1%

day_of_week
Real number (ℝ)

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.9977495

Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.2 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	7
Maximum	7
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	1.9977421
Coefficient of variation (CV)	0.4997167
Kurtosis	-1.2470392
Mean	3.9977495
Median Absolute Deviation (MAD)	2
Skewness	0.0017088695
Sum	2938074
Variance	3.9909737
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
5	105361	14.3%
4	105338	14.3%
3	105268	14.3%
2	105114	14.3%
1	104757	14.3%
7	104564	14.2%
6	104530	14.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	104757	14.3%
2	105114	14.3%
3	105268	14.3%
4	105338	14.3%
5	105361	14.3%
6	104530	14.2%
7	104564	14.2%

Value	Count	Frequency (%)
7	104564	14.2%
6	104530	14.2%
5	105361	14.3%
4	105338	14.3%
3	105268	14.3%
2	105114	14.3%
1	104757	14.3%

date
Date

Distinct	942
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.2 MiB

Minimum	2013-01-01 00:00:00
Maximum	2015-07-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

customers
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	3962
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	632.96202

Minimum	0
Maximum	7388
Zeros	124977
Zeros (%)	17.0%
Negative	0
Negative (%)	0.0%
Memory size	11.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	404
median	609
Q3	837
95-th percentile	1361
Maximum	7388
Range	7388
Interquartile range (IQR)	433

Descriptive statistics

Standard deviation	464.21296
Coefficient of variation (CV)	0.7333978
Kurtosis	7.1147692
Mean	632.96202
Median Absolute Deviation (MAD)	216
Skewness	1.5982741
Sum	4.6518404 × 10⁸
Variance	215493.67
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	124977	17.0%
560	1796	0.2%
576	1727	0.2%
533	1699	0.2%
555	1694	0.2%
651	1692	0.2%
566	1687	0.2%
614	1684	0.2%
603	1683	0.2%
517	1670	0.2%
Other values (3952)	594623	80.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	124977	17.0%
3	1	< 0.1%
5	1	< 0.1%
8	1	< 0.1%
13	1	< 0.1%
36	1	< 0.1%
40	1	< 0.1%
50	1	< 0.1%
61	1	< 0.1%
64	1	< 0.1%

Value	Count	Frequency (%)
7388	1	< 0.1%
5494	1	< 0.1%
5387	1	< 0.1%
5297	1	< 0.1%
5192	1	< 0.1%
5152	1	< 0.1%
5112	1	< 0.1%
5106	1	< 0.1%
5090	1	< 0.1%
5069	1	< 0.1%

open
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.2 MiB

1	609995
0	124937

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	734932
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	1
4th row	0
5th row	1

Common Values

Value	Count	Frequency (%)
1	609995	83.0%
0	124937	17.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	609995	83.0%
0	124937	17.0%

Most occurring characters

Value	Count	Frequency (%)
1	609995	83.0%
0	124937	17.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	734932	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	609995	83.0%
0	124937	17.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	734932	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	609995	83.0%
0	124937	17.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	734932	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	609995	83.0%
0	124937	17.0%

promo
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.2 MiB

0	454226
1	280706

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	734932
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	1
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	454226	61.8%
1	280706	38.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	454226	61.8%
1	280706	38.2%

Most occurring characters

Value	Count	Frequency (%)
0	454226	61.8%
1	280706	38.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	734932	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	454226	61.8%
1	280706	38.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	734932	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	454226	61.8%
1	280706	38.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	734932	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	454226	61.8%
1	280706	38.2%

state_holiday
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.2 MiB

0	712422
a	14691
b	4844
c	2975

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	734932
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	712422	96.9%
a	14691	2.0%
b	4844	0.7%
c	2975	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	712422	96.9%
a	14691	2.0%
b	4844	0.7%
c	2975	0.4%

Most occurring characters

Value	Count	Frequency (%)
0	712422	96.9%
a	14691	2.0%
b	4844	0.7%
c	2975	0.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	712422	96.9%
Lowercase Letter	22510	3.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	14691	65.3%
b	4844	21.5%
c	2975	13.2%

Decimal Number

Value	Count	Frequency (%)
0	712422	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	712422	96.9%
Latin	22510	3.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	14691	65.3%
b	4844	21.5%
c	2975	13.2%

Common

Value	Count	Frequency (%)
0	712422	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	734932	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	712422	96.9%
a	14691	2.0%
b	4844	0.7%
c	2975	0.4%

school_holiday
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.2 MiB

0	603648
1	131284

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	734932
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	1

Common Values

Value	Count	Frequency (%)
0	603648	82.1%
1	131284	17.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	603648	82.1%
1	131284	17.9%

Most occurring characters

Value	Count	Frequency (%)
0	603648	82.1%
1	131284	17.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	734932	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	603648	82.1%
1	131284	17.9%

Most occurring scripts

Value	Count	Frequency (%)
Common	734932	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	603648	82.1%
1	131284	17.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	734932	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	603648	82.1%
1	131284	17.9%

store_type
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.2 MiB

a	398944
d	225963
c	98696
b	11329

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	734932
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	a
2nd row	a
3rd row	a
4th row	a
5th row	c

Common Values

Value	Count	Frequency (%)
a	398944	54.3%
d	225963	30.7%
c	98696	13.4%
b	11329	1.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
a	398944	54.3%
d	225963	30.7%
c	98696	13.4%
b	11329	1.5%

Most occurring characters

Value	Count	Frequency (%)
a	398944	54.3%
d	225963	30.7%
c	98696	13.4%
b	11329	1.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	734932	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	398944	54.3%
d	225963	30.7%
c	98696	13.4%
b	11329	1.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	734932	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	398944	54.3%
d	225963	30.7%
c	98696	13.4%
b	11329	1.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	734932	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	398944	54.3%
d	225963	30.7%
c	98696	13.4%
b	11329	1.5%

assortment
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.2 MiB

a	388938
c	340027
b	5967

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	734932
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	c
2nd row	c
3rd row	c
4th row	a
5th row	a

Common Values

Value	Count	Frequency (%)
a	388938	52.9%
c	340027	46.3%
b	5967	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
a	388938	52.9%
c	340027	46.3%
b	5967	0.8%

Most occurring characters

Value	Count	Frequency (%)
a	388938	52.9%
c	340027	46.3%
b	5967	0.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	734932	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	388938	52.9%
c	340027	46.3%
b	5967	0.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	734932	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	388938	52.9%
c	340027	46.3%
b	5967	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	734932	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	388938	52.9%
c	340027	46.3%
b	5967	0.8%

competition_distance
Real number (ℝ)

Distinct	655
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5928.7621

Minimum	20
Maximum	200000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.2 MiB

Quantile statistics

Minimum	20
5-th percentile	130
Q1	710
median	2330
Q3	6900
95-th percentile	20620
Maximum	200000
Range	199980
Interquartile range (IQR)	6190

Descriptive statistics

Standard deviation	12551.454
Coefficient of variation (CV)	2.1170447
Kurtosis	147.86516
Mean	5928.7621
Median Absolute Deviation (MAD)	1980
Skewness	10.248645
Sum	4.357237 × 10⁹
Variance	1.5753901 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
250	8017	1.1%
350	5433	0.7%
50	5427	0.7%
190	5396	0.7%
1200	5308	0.7%
90	4771	0.6%
180	4759	0.6%
330	4615	0.6%
150	4537	0.6%
2640	4108	0.6%
Other values (645)	682561	92.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20	675	0.1%
30	2746	0.4%
40	3463	0.5%
50	5427	0.7%
60	2051	0.3%
70	3276	0.4%
80	2044	0.3%
90	4771	0.6%
100	3405	0.5%
110	3906	0.5%

Value	Count	Frequency (%)
200000	1912	0.3%
75860	674	0.1%
58260	679	0.1%
48330	677	0.1%
46590	677	0.1%
45740	661	0.1%
44320	695	0.1%
40860	697	0.1%
40540	662	0.1%
38710	701	0.1%

competition_open_since_month
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.7827976

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.4 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	4
median	7
Q3	10
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.3105199
Coefficient of variation (CV)	0.48807588
Kurtosis	-1.2326458
Mean	6.7827976
Median Absolute Deviation (MAD)	3
Skewness	-0.039781499
Sum	4984895
Variance	10.959542
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
9	96573	13.1%
4	85963	11.7%
11	74996	10.2%
3	69994	9.5%
7	65563	8.9%
12	56394	7.7%
6	55917	7.6%
10	54732	7.4%
5	52526	7.1%
2	48863	6.6%
Other values (2)	73411	10.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	32741	4.5%
2	48863	6.6%
3	69994	9.5%
4	85963	11.7%
5	52526	7.1%
6	55917	7.6%
7	65563	8.9%
8	40670	5.5%
9	96573	13.1%
10	54732	7.4%

Value	Count	Frequency (%)
12	56394	7.7%
11	74996	10.2%
10	54732	7.4%
9	96573	13.1%
8	40670	5.5%
7	65563	8.9%
6	55917	7.6%
5	52526	7.1%
4	85963	11.7%
3	69994	9.5%

competition_open_since_year
Real number (ℝ)

Distinct	23
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2010.3233

Minimum	1900
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.4 MiB

Quantile statistics

Minimum	1900
5-th percentile	2002
Q1	2008
median	2012
Q3	2014
95-th percentile	2015
Maximum	2015
Range	115
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	5.536153
Coefficient of variation (CV)	0.0027538621
Kurtosis	125.26688
Mean	2010.3233
Median Absolute Deviation (MAD)	2
Skewness	-7.3090883
Sum	1.4774509 × 10⁹
Variance	30.64899
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
2013	147998	20.1%
2014	132033	18.0%
2015	79378	10.8%
2012	53849	7.3%
2005	40765	5.5%
2010	37027	5.0%
2009	35809	4.9%
2011	35669	4.9%
2008	35010	4.8%
2007	31502	4.3%
Other values (13)	105892	14.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1900	562	0.1%
1961	681	0.1%
1990	3390	0.5%
1994	1384	0.2%
1995	1238	0.2%
1998	674	0.1%
1999	5275	0.7%
2000	6659	0.9%
2001	10728	1.5%
2002	17838	2.4%

Value	Count	Frequency (%)
2015	79378	10.8%
2014	132033	18.0%
2013	147998	20.1%
2012	53849	7.3%
2011	35669	4.9%
2010	37027	5.0%
2009	35809	4.9%
2008	35010	4.8%
2007	31502	4.3%
2006	30966	4.2%

promo2
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.2 MiB

1	368064
0	366868

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	734932
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	0
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	368064	50.1%
0	366868	49.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	368064	50.1%
0	366868	49.9%

Most occurring characters

Value	Count	Frequency (%)
1	368064	50.1%
0	366868	49.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	734932	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	368064	50.1%
0	366868	49.9%

Most occurring scripts

Value	Count	Frequency (%)
Common	734932	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	368064	50.1%
0	366868	49.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	734932	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	368064	50.1%
0	366868	49.9%

promo2_since_week
Real number (ℝ)

Distinct	52
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.612393

Minimum	1
Maximum	52
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.4 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	12
median	22
Q3	37
95-th percentile	47
Maximum	52
Range	51
Interquartile range (IQR)	25

Descriptive statistics

Standard deviation	14.307916
Coefficient of variation (CV)	0.60594943
Kurtosis	-1.1844802
Mean	23.612393
Median Absolute Deviation (MAD)	12
Skewness	0.17935973
Sum	17353503
Variance	204.71646
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14	61114	8.3%
40	50652	6.9%
10	36560	5.0%
31	36167	4.9%
5	34059	4.6%
1	31226	4.2%
13	29873	4.1%
37	29102	4.0%
22	28940	3.9%
18	27986	3.8%
Other values (42)	369253	50.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	31226	4.2%
2	8275	1.1%
3	8221	1.1%
4	8242	1.1%
5	34059	4.6%
6	8955	1.2%
7	8191	1.1%
8	8303	1.1%
9	17191	2.3%
10	36560	5.0%

Value	Count	Frequency (%)
52	5319	0.7%
51	5345	0.7%
50	6041	0.8%
49	5902	0.8%
48	11417	1.6%
47	5399	0.7%
46	5400	0.7%
45	26597	3.6%
44	7265	1.0%
43	5368	0.7%

promo2_since_year
Real number (ℝ)

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2012.7932

Minimum	2009
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.4 MiB

Quantile statistics

Minimum	2009
5-th percentile	2009
Q1	2012
median	2013
Q3	2014
95-th percentile	2015
Maximum	2015
Range	6
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.6634744
Coefficient of variation (CV)	0.00082645073
Kurtosis	-0.21233728
Mean	2012.7932
Median Absolute Deviation (MAD)	1
Skewness	-0.7841154
Sum	1.4792661 × 10⁹
Variance	2.767147
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
2013	223052	30.4%
2014	198092	27.0%
2015	89969	12.2%
2011	83174	11.3%
2012	52739	7.2%
2009	47220	6.4%
2010	40686	5.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2009	47220	6.4%
2010	40686	5.5%
2011	83174	11.3%
2012	52739	7.2%
2013	223052	30.4%
2014	198092	27.0%
2015	89969	12.2%

Value	Count	Frequency (%)
2015	89969	12.2%
2014	198092	27.0%
2013	223052	30.4%
2012	52739	7.2%
2011	83174	11.3%
2010	40686	5.5%
2009	47220	6.4%

promo_interval
Unsupported

REJECTED UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	11.2 MiB

sales
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	20629
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5770.9286

Minimum	0
Maximum	41551
Zeros	124979
Zeros (%)	17.0%
Negative	0
Negative (%)	0.0%
Memory size	11.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3725
median	5743
Q3	7857
95-th percentile	12120
Maximum	41551
Range	41551
Interquartile range (IQR)	4132

Descriptive statistics

Standard deviation	3847.5133
Coefficient of variation (CV)	0.66670611
Kurtosis	1.7789504
Mean	5770.9286
Median Absolute Deviation (MAD)	2068
Skewness	0.63968359
Sum	4.2412401 × 10⁹
Variance	14803359
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	124979	17.0%
5674	157	< 0.1%
5931	147	< 0.1%
5449	145	< 0.1%
5489	145	< 0.1%
6615	144	< 0.1%
5041	142	< 0.1%
5989	141	< 0.1%
5558	140	< 0.1%
5096	139	< 0.1%
Other values (20619)	608653	82.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	124979	17.0%
46	1	< 0.1%
124	1	< 0.1%
286	1	< 0.1%
297	1	< 0.1%
416	1	< 0.1%
520	1	< 0.1%
530	1	< 0.1%
538	1	< 0.1%
541	1	< 0.1%

Value	Count	Frequency (%)
41551	1	< 0.1%
38367	1	< 0.1%
38037	1	< 0.1%
38025	1	< 0.1%
37403	1	< 0.1%
37376	1	< 0.1%
36227	1	< 0.1%
35909	1	< 0.1%
35702	1	< 0.1%
35154	1	< 0.1%

month_map
Categorical

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.2 MiB

Mar	75250
May	74942
Jan	74892
Jun	72526
Apr	72500
Other values (7)	364822

Length

Max length	4
Median length	3
Mean length	3.0604138
Min length	3

Characters and Unicode

Total characters	2249196
Distinct characters	21
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Jan
2nd row	Fev
3rd row	Jan
4th row	Jun
5th row	Apr

Common Values

Value	Count	Frequency (%)
Mar	75250	10.2%
May	74942	10.2%
Jan	74892	10.2%
Jun	72526	9.9%
Apr	72500	9.9%
Jul	70862	9.6%
Fev	67641	9.2%
Aug	46025	6.3%
Oct	45789	6.2%
Dec	45676	6.2%
Other values (2)	88829	12.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
mar	75250	10.2%
may	74942	10.2%
jan	74892	10.2%
jun	72526	9.9%
apr	72500	9.9%
jul	70862	9.6%
fev	67641	9.2%
aug	46025	6.3%
oct	45789	6.2%
dec	45676	6.2%
Other values (2)	88829	12.1%

Most occurring characters

Value	Count	Frequency (%)
a	225084	10.0%
J	218280	9.7%
u	189413	8.4%
e	157717	7.0%
M	150192	6.7%
r	147750	6.6%
n	147418	6.6%
A	118525	5.3%
p	116900	5.2%
v	112070	5.0%
Other values (11)	665847	29.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1514264	67.3%
Uppercase Letter	734932	32.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	225084	14.9%
u	189413	12.5%
e	157717	10.4%
r	147750	9.8%
n	147418	9.7%
p	116900	7.7%
v	112070	7.4%
c	91465	6.0%
t	90189	6.0%
y	74942	4.9%
Other values (3)	161316	10.7%

Uppercase Letter

Value	Count	Frequency (%)
J	218280	29.7%
M	150192	20.4%
A	118525	16.1%
F	67641	9.2%
O	45789	6.2%
D	45676	6.2%
N	44429	6.0%
S	44400	6.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2249196	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	225084	10.0%
J	218280	9.7%
u	189413	8.4%
e	157717	7.0%
M	150192	6.7%
r	147750	6.6%
n	147418	6.6%
A	118525	5.3%
p	116900	5.2%
v	112070	5.0%
Other values (11)	665847	29.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2249196	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	225084	10.0%
J	218280	9.7%
u	189413	8.4%
e	157717	7.0%
M	150192	6.7%
r	147750	6.6%
n	147418	6.6%
A	118525	5.3%
p	116900	5.2%
v	112070	5.0%
Other values (11)	665847	29.6%

is_promo
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.2 MiB

0	616567
1	118365

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	734932
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	616567	83.9%
1	118365	16.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	616567	83.9%
1	118365	16.1%

Most occurring characters

Value	Count	Frequency (%)
0	616567	83.9%
1	118365	16.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	734932	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	616567	83.9%
1	118365	16.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	734932	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	616567	83.9%
1	118365	16.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	734932	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	616567	83.9%
1	118365	16.1%

Auto

Heatmap
Table

	store	day_of_week	customers	competition_distance	competition_open_since_month	competition_open_since_year	promo2_since_week	promo2_since_year	sales	open	promo	state_holiday	school_holiday	store_type	assortment	promo2	month_map	is_promo
store	1.000	0.000	0.021	-0.046	-0.033	0.004	0.005	0.008	0.000	0.006	0.000	0.000	0.002	0.095	0.111	0.072	0.000	0.035
day_of_week	0.000	1.000	-0.432	0.001	-0.002	0.000	-0.003	0.001	-0.451	0.875	0.496	0.120	0.264	0.000	0.000	0.000	0.031	0.011
customers	0.021	-0.432	1.000	-0.180	0.003	0.015	0.032	0.121	0.903	0.327	0.279	0.071	0.047	0.318	0.273	0.181	0.024	0.081
competition_distance	-0.046	0.001	-0.180	1.000	-0.024	0.009	-0.014	0.030	-0.027	0.013	0.000	0.000	0.002	0.045	0.062	0.159	0.000	0.070
competition_open_since_month	-0.033	-0.002	0.003	-0.024	1.000	-0.233	0.108	0.017	-0.002	0.024	0.013	0.061	0.132	0.068	0.058	0.132	0.326	0.084
competition_open_since_year	0.004	0.000	0.015	0.009	-0.233	1.000	0.018	0.030	0.029	0.000	0.000	0.002	0.000	0.055	0.078	0.054	0.001	0.029
promo2_since_week	0.005	-0.003	0.032	-0.014	0.108	0.018	1.000	-0.121	0.056	0.033	0.051	0.102	0.182	0.072	0.091	0.283	0.432	0.160
promo2_since_year	0.008	0.001	0.121	0.030	0.017	0.030	-0.121	1.000	0.062	0.005	0.015	0.016	0.026	0.084	0.109	0.682	0.099	0.304
sales	0.000	-0.451	0.903	-0.027	-0.002	0.029	0.056	0.062	1.000	0.705	0.453	0.155	0.083	0.107	0.081	0.104	0.044	0.051
open	0.006	0.875	0.327	0.013	0.024	0.000	0.033	0.005	0.705	1.000	0.295	0.379	0.087	0.051	0.039	0.008	0.074	0.000
promo	0.000	0.496	0.279	0.000	0.013	0.000	0.051	0.015	0.453	0.295	1.000	0.054	0.067	0.000	0.000	0.000	0.052	0.005
state_holiday	0.000	0.120	0.071	0.000	0.061	0.002	0.102	0.016	0.155	0.379	0.054	1.000	0.213	0.002	0.001	0.011	0.220	0.027
school_holiday	0.002	0.264	0.047	0.002	0.132	0.000	0.182	0.026	0.083	0.087	0.067	0.213	1.000	0.003	0.002	0.007	0.385	0.026
store_type	0.095	0.000	0.318	0.045	0.068	0.055	0.072	0.084	0.107	0.051	0.000	0.002	0.003	1.000	0.539	0.105	0.007	0.045
assortment	0.111	0.000	0.273	0.062	0.058	0.078	0.091	0.109	0.081	0.039	0.000	0.001	0.002	0.539	1.000	0.014	0.005	0.008
promo2	0.072	0.000	0.181	0.159	0.132	0.054	0.283	0.682	0.104	0.008	0.000	0.011	0.007	0.105	0.014	1.000	0.029	0.437
month_map	0.000	0.031	0.024	0.000	0.326	0.001	0.432	0.099	0.044	0.074	0.052	0.220	0.385	0.007	0.005	0.029	1.000	0.274
is_promo	0.035	0.011	0.081	0.070	0.084	0.029	0.160	0.304	0.051	0.000	0.005	0.027	0.026	0.045	0.008	0.437	0.274	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	store	day_of_week	date	customers	open	promo	school_holiday	store_type	assortment	competition_distance	competition_open_since_month	competition_open_since_year	promo2	promo2_since_week	promo2_since_year	promo_interval	sales	month_map	is_promo
582092	848	7	2014-01-26	0	0	0	0	a	c	370.000	7	2007	1	14	2011	Jan,Apr,Jul,Oct	0	Jan	1
184305	331	1	2015-02-16	803	1	1	0	a	c	670.000	2	2015	1	14	2015	Jan,Apr,Jul,Oct	7039	Fev	0
223725	726	1	2015-01-12	1437	1	1	0	a	c	40540.000	2	2002	0	3	2015	0	15611	Jan	0
60746	537	7	2015-06-07	0	0	0	0	a	a	600.000	5	2002	1	1	2012	Jan,Apr,Jul,Oct	0	Jun	0
485468	114	2	2014-04-22	550	1	0	1	c	a	4510.000	4	2014	1	48	2011	Mar,Jun,Sept,Dec	4260	Apr	0
209171	667	7	2015-01-25	0	0	0	0	d	c	2870.000	9	2012	0	4	2015	0	0	Jan	0
992815	136	2	2013-01-22	424	1	1	0	a	c	2200.000	12	2010	1	22	2012	Feb,May,Aug,Nov	5360	Jan	0
758907	378	2	2013-08-20	764	1	0	1	a	c	2140.000	8	2012	0	34	2013	0	4536	Aug	0
561223	49	4	2014-02-13	464	1	0	0	d	c	18010.000	9	2007	0	7	2014	0	5822	Fev	0
33999	550	3	2015-07-01	402	1	1	0	d	c	50.000	6	2015	0	27	2015	0	5605	Jul	0

	store	day_of_week	date	customers	open	promo	school_holiday	store_type	assortment	competition_distance	competition_open_since_month	competition_open_since_year	promo2	promo2_since_week	promo2_since_year	promo_interval	sales	month_map
669466	137	5	2013-11-08	1088	1	1	0	a	a	1730.000	7	2015	1	40	2014	Jan,Apr,Jul,Oct	9252	Nov
995705	796	7	2013-01-20	0	0	0	0	a	c	7180.000	11	2012	0	3	2013	0	0	Jan
356367	369	1	2014-08-25	513	1	0	1	d	c	5870.000	4	2014	0	35	2014	0	5325	Aug
940624	350	7	2013-03-10	0	0	0	0	d	a	8880.000	3	2013	1	14	2011	Jan,Apr,Jul,Oct	0	Mar
68154	140	7	2015-05-31	0	0	0	0	a	c	1090.000	7	2010	1	1	2013	Jan,Apr,Jul,Oct	0	May
23715	301	5	2015-07-10	608	1	0	0	a	c	4510.000	3	2015	0	28	2015	0	5588	Jul
615742	1048	5	2013-12-27	562	1	0	1	d	c	1860.000	9	2012	1	40	2012	Jan,Apr,Jul,Oct	6416	Dec
783713	654	1	2013-07-29	950	1	1	1	c	a	6930.000	9	2006	0	31	2013	0	10257	Jul
982497	968	5	2013-02-01	955	1	0	0	c	a	1190.000	2	2013	0	5	2013	0	7285	Fev
533203	1019	2	2014-03-11	555	1	0	0	d	c	2740.000	7	2014	1	13	2010	Jan,Apr,Jul,Oct	6006	Mar

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks